public/ipa files - Interbull Centre Wiki

FILE FORMAT FOR INTERNATIONAL PARENT AVERAGE MACE/GMACE

Field Description	Format
Record type (1)	character 3
Breed of evaluation (2)	character 3
Bull international identification (3)
Breed of bull	character 3
Country of registration of bull (4)	character 3
Sex	character 1
ID number of bull (5)	character 12

EMPTY SPACE	1
Date of international evaluation (YYYYMM)	integer 6

Number of repeated segments for this file
number of countries	integer 3
number of traits (7)	integer 6

International proof in each country (8)
EMPTY SPACE	1
Country code	character 3
Parent average for TRAIT i (x1000) (9)	integer 10

KEY TO: INTERBULL GENETIC EVALUATION FILE FORMAT

060 = Interbull Production File; 065 = Interbull Conformation File; 066 = Interbull Udder health file; 067 = Interbull Longevity File; 068 = Interbull Calving File; 069 = Interbull Female Fertility File; 070 = Interbull Workability File; 071= Interbull SNP Training for Clinical Mastitis File
BSW = Brown Swiss, GUE = Guernsey, HOL = Holsteins, JER = Jersey, RDC = Red Dairy Cattle, SIM = Simmental
International identification in the country of first registration as known at the Interbull Centre; this is the first ID in new cross-reference list Xrefmult.*** found on the Interbull ftp site (where *** refer to breed).
Country codes of Interbull members (in alphabetical order):
- ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; BUL=Bulgaria;
  CAN=Canada; HRV=Croatia; CZE=Czech Republic; [DFS:Denmark,Finland,Sweden]; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; [DEU=Germany,Austria]; DEU=Germany; GRC=Greece; HUN=Hungary; IRL=Ireland; ISR=Israel; ITA=Italy; JPN=Japan; KOR=Korea; LVA=Lathvia; LTU=Lithuania; LUX=Luxembourg; MEX=Mexico; NLD=Netherlands; NZL=New Zealand; NOR=Norway; POL=Poland; PRT=Portugal; SVK=Slovak Republic; SVN=Slovenia; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; GBR=United Kingdom; USA=United States of America.
ID numbers: Registration numbers, right justified, leading blanks as zeros.
Y = Bull meets standard for official publication in at least one country.
Number of traits:
- Production i = 3 (1=mi, 2=fa, 3=pr ) Udder health i = 2 (1=sc, 2=ma ) Longevity i = 1 (1=dl ) Calving i = 4 (1=dc, 2=mc, 3=ds, 4=ms ) Fertility i = 5 (1=ch, 2=cy, 3=c1, 4=c2, 5=it) Workability i = 2 (1=md, 2=te ) Conformation BSW i= 22 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=fan 9=hde 10=fua 11=ruh 12=ruw 13=usu 14=ude 15=ftp 16=ftl 17=rtp 18=ocs 19=ous 20=ofl 21=loc 22=bcs) RDC HOL JER GUE i= 21 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=rlr 9=fan 10=fua 11=ruh 12=usu 13=ude 14=ftp 15=ftl 16=rtp 17=ocs 18=ous 19=ofl 20=loc 21=bcs)
Repeat as necessary depending on number of countries;
Parent averages in base and unit of each country; proofs are multiplied by 1000 to include 3 decimals; missing values are represented by 999999.